Dataset statistics
| Number of variables | 12 |
|---|---|
| Number of observations | 2599 |
| Missing cells | 3928 |
| Missing cells (%) | 12.6% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 243.8 KiB |
| Average record size in memory | 96.0 B |
Variable types
| Categorical | 3 |
|---|---|
| Numeric | 9 |
County FIPS Code has a high cardinality: 2599 distinct values | High cardinality |
County Name has a high cardinality: 1583 distinct values | High cardinality |
< 100% of FPL is highly correlated with ≥ 100% to ≤ 150% of FPL and 7 other fields | High correlation |
≥ 100% to ≤ 150% of FPL is highly correlated with < 100% of FPL and 7 other fields | High correlation |
> 150% to ≤ 200% of FPL is highly correlated with < 100% of FPL and 7 other fields | High correlation |
> 200% to ≤ 250% of FPL is highly correlated with < 100% of FPL and 7 other fields | High correlation |
> 250% to ≤ 300% of FPL is highly correlated with < 100% of FPL and 7 other fields | High correlation |
> 300% to ≤ 400% of FPL is highly correlated with < 100% of FPL and 7 other fields | High correlation |
> 400% of FPL is highly correlated with < 100% of FPL and 7 other fields | High correlation |
Unknown is highly correlated with < 100% of FPL and 7 other fields | High correlation |
Total Plan Selections is highly correlated with < 100% of FPL and 7 other fields | High correlation |
< 100% of FPL is highly correlated with ≥ 100% to ≤ 150% of FPL and 7 other fields | High correlation |
≥ 100% to ≤ 150% of FPL is highly correlated with < 100% of FPL and 7 other fields | High correlation |
> 150% to ≤ 200% of FPL is highly correlated with < 100% of FPL and 7 other fields | High correlation |
> 200% to ≤ 250% of FPL is highly correlated with < 100% of FPL and 7 other fields | High correlation |
> 250% to ≤ 300% of FPL is highly correlated with < 100% of FPL and 7 other fields | High correlation |
> 300% to ≤ 400% of FPL is highly correlated with < 100% of FPL and 7 other fields | High correlation |
> 400% of FPL is highly correlated with < 100% of FPL and 7 other fields | High correlation |
Unknown is highly correlated with < 100% of FPL and 7 other fields | High correlation |
Total Plan Selections is highly correlated with < 100% of FPL and 7 other fields | High correlation |
< 100% of FPL is highly correlated with ≥ 100% to ≤ 150% of FPL and 7 other fields | High correlation |
≥ 100% to ≤ 150% of FPL is highly correlated with < 100% of FPL and 7 other fields | High correlation |
> 150% to ≤ 200% of FPL is highly correlated with < 100% of FPL and 7 other fields | High correlation |
> 200% to ≤ 250% of FPL is highly correlated with < 100% of FPL and 7 other fields | High correlation |
> 250% to ≤ 300% of FPL is highly correlated with < 100% of FPL and 7 other fields | High correlation |
> 300% to ≤ 400% of FPL is highly correlated with < 100% of FPL and 7 other fields | High correlation |
> 400% of FPL is highly correlated with < 100% of FPL and 7 other fields | High correlation |
Unknown is highly correlated with < 100% of FPL and 7 other fields | High correlation |
Total Plan Selections is highly correlated with < 100% of FPL and 7 other fields | High correlation |
< 100% of FPL is highly correlated with ≥ 100% to ≤ 150% of FPL and 7 other fields | High correlation |
≥ 100% to ≤ 150% of FPL is highly correlated with < 100% of FPL and 7 other fields | High correlation |
> 150% to ≤ 200% of FPL is highly correlated with < 100% of FPL and 7 other fields | High correlation |
> 200% to ≤ 250% of FPL is highly correlated with < 100% of FPL and 7 other fields | High correlation |
> 250% to ≤ 300% of FPL is highly correlated with < 100% of FPL and 7 other fields | High correlation |
> 300% to ≤ 400% of FPL is highly correlated with < 100% of FPL and 7 other fields | High correlation |
> 400% of FPL is highly correlated with < 100% of FPL and 7 other fields | High correlation |
Unknown is highly correlated with < 100% of FPL and 7 other fields | High correlation |
Total Plan Selections is highly correlated with < 100% of FPL and 7 other fields | High correlation |
< 100% of FPL has 1228 (47.2%) missing values | Missing |
≥ 100% to ≤ 150% of FPL has 71 (2.7%) missing values | Missing |
> 150% to ≤ 200% of FPL has 59 (2.3%) missing values | Missing |
> 200% to ≤ 250% of FPL has 93 (3.6%) missing values | Missing |
> 250% to ≤ 300% of FPL has 223 (8.6%) missing values | Missing |
> 300% to ≤ 400% of FPL has 319 (12.3%) missing values | Missing |
> 400% of FPL has 1283 (49.4%) missing values | Missing |
Unknown has 650 (25.0%) missing values | Missing |
≥ 100% to ≤ 150% of FPL is highly skewed (γ1 = 23.84829317) | Skewed |
County FIPS Code is uniformly distributed | Uniform |
County FIPS Code has unique values | Unique |
< 100% of FPL has 134 (5.2%) zeros | Zeros |
> 400% of FPL has 214 (8.2%) zeros | Zeros |
Unknown has 49 (1.9%) zeros | Zeros |
Reproduction
| Analysis started | 2022-04-06 01:15:18.812940 |
|---|---|
| Analysis finished | 2022-04-06 01:15:33.468325 |
| Duration | 14.66 seconds |
| Software version | pandas-profiling v3.1.0 |
| Download configuration | config.json |
| Distinct | 2599 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 20.4 KiB |
| 48303 | 1 |
|---|---|
| 31119 | 1 |
| 48507 | 1 |
| 40079 | 1 |
| 22019 | 1 |
| Other values (2594) |
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 4.928434013 |
| Min length | 4 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 2599 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | 2013 |
|---|---|
| 2nd row | 2016 |
| 3rd row | 2020 |
| 4th row | 2050 |
| 5th row | 2060 |
Common Values
| Value | Count | Frequency (%) |
| 48303 | 1 | < 0.1% |
| 31119 | 1 | < 0.1% |
| 48507 | 1 | < 0.1% |
| 40079 | 1 | < 0.1% |
| 22019 | 1 | < 0.1% |
| 47119 | 1 | < 0.1% |
| 48161 | 1 | < 0.1% |
| 31125 | 1 | < 0.1% |
| 31123 | 1 | < 0.1% |
| 56035 | 1 | < 0.1% |
| Other values (2589) | 2589 |
Length
| Value | Count | Frequency (%) |
| 48303 | 1 | < 0.1% |
| 54027 | 1 | < 0.1% |
| 13321 | 1 | < 0.1% |
| 55089 | 1 | < 0.1% |
| 47029 | 1 | < 0.1% |
| 42025 | 1 | < 0.1% |
| 39097 | 1 | < 0.1% |
| 46093 | 1 | < 0.1% |
| 18067 | 1 | < 0.1% |
| 51171 | 1 | < 0.1% |
| Other values (2589) | 2589 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
State Name
Categorical
| Distinct | 38 |
|---|---|
| Distinct (%) | 1.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 20.4 KiB |
| TX | |
|---|---|
| GA | 159 |
| VA | 134 |
| MO | 115 |
| KS | 105 |
| Other values (33) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | AK |
|---|---|
| 2nd row | AK |
| 3rd row | AK |
| 4th row | AK |
| 5th row | AK |
Common Values
| Value | Count | Frequency (%) |
| TX | 254 | 9.8% |
| GA | 159 | 6.1% |
| VA | 134 | 5.2% |
| MO | 115 | 4.4% |
| KS | 105 | 4.0% |
| IL | 102 | 3.9% |
| NC | 100 | 3.8% |
| IA | 99 | 3.8% |
| TN | 95 | 3.7% |
| NE | 93 | 3.6% |
| Other values (28) | 1343 |
Length
| Value | Count | Frequency (%) |
| tx | 254 | 9.8% |
| ga | 159 | 6.1% |
| va | 134 | 5.2% |
| mo | 115 | 4.4% |
| ks | 105 | 4.0% |
| il | 102 | 3.9% |
| nc | 100 | 3.8% |
| ia | 99 | 3.8% |
| tn | 95 | 3.7% |
| ne | 93 | 3.6% |
| Other values (28) | 1343 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 1583 |
|---|---|
| Distinct (%) | 60.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 20.4 KiB |
| Washington County | 22 |
|---|---|
| Jackson County | 20 |
| Jefferson County | 20 |
| Franklin County | 18 |
| Lincoln County | 18 |
| Other values (1578) |
Length
| Max length | 33 |
|---|---|
| Median length | 14 |
| Mean length | 14.00230858 |
| Min length | 7 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 1227 ? |
|---|---|
| Unique (%) | 47.2% |
Sample
| 1st row | Aleutians East Borough |
|---|---|
| 2nd row | Aleutians West Census Area |
| 3rd row | Anchorage Municipality |
| 4th row | Bethel Census Area |
| 5th row | Bristol Bay Borough |
Common Values
| Value | Count | Frequency (%) |
| Washington County | 22 | 0.8% |
| Jackson County | 20 | 0.8% |
| Jefferson County | 20 | 0.8% |
| Franklin County | 18 | 0.7% |
| Lincoln County | 18 | 0.7% |
| Union County | 16 | 0.6% |
| Clay County | 16 | 0.6% |
| Madison County | 16 | 0.6% |
| Marion County | 16 | 0.6% |
| Monroe County | 15 | 0.6% |
| Other values (1573) | 2422 |
Length
| Value | Count | Frequency (%) |
| county | 2464 | |
| parish | 64 | 1.2% |
| city | 47 | 0.9% |
| st | 23 | 0.4% |
| washington | 23 | 0.4% |
| jefferson | 23 | 0.4% |
| jackson | 21 | 0.4% |
| franklin | 20 | 0.4% |
| lincoln | 19 | 0.4% |
| union | 17 | 0.3% |
| Other values (1571) | 2655 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
< 100% of FPL
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSINGZEROS| Distinct | 342 |
|---|---|
| Distinct (%) | 24.9% |
| Missing | 1228 |
| Missing (%) | 47.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 160.1167031 |
| Minimum | 0 |
|---|---|
| Maximum | 7886 |
| Zeros | 134 |
| Zeros (%) | 5.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 20.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 19 |
| median | 42 |
| Q3 | 107.5 |
| 95-th percentile | 699.5 |
| Maximum | 7886 |
| Range | 7886 |
| Interquartile range (IQR) | 88.5 |
Descriptive statistics
| Standard deviation | 460.4733484 |
|---|---|
| Coefficient of variation (CV) | 2.87586079 |
| Kurtosis | 94.67786369 |
| Mean | 160.1167031 |
| Median Absolute Deviation (MAD) | 28 |
| Skewness | 8.22466995 |
| Sum | 219520 |
| Variance | 212035.7046 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 134 | 5.2% |
| 21 | 28 | 1.1% |
| 16 | 27 | 1.0% |
| 17 | 26 | 1.0% |
| 13 | 25 | 1.0% |
| 15 | 25 | 1.0% |
| 14 | 25 | 1.0% |
| 11 | 25 | 1.0% |
| 12 | 25 | 1.0% |
| 19 | 24 | 0.9% |
| Other values (332) | 1007 | |
| (Missing) | 1228 |
| Value | Count | Frequency (%) |
| 0 | 134 | |
| 11 | 25 | 1.0% |
| 12 | 25 | 1.0% |
| 13 | 25 | 1.0% |
| 14 | 25 | 1.0% |
| 15 | 25 | 1.0% |
| 16 | 27 | 1.0% |
| 17 | 26 | 1.0% |
| 18 | 17 | 0.7% |
| 19 | 24 | 0.9% |
| Value | Count | Frequency (%) |
| 7886 | 1 | |
| 5236 | 1 | |
| 5137 | 1 | |
| 4431 | 1 | |
| 4222 | 1 | |
| 3194 | 1 | |
| 3139 | 1 | |
| 2958 | 1 | |
| 2803 | 1 | |
| 2792 | 1 |
≥ 100% to ≤ 150% of FPL
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSINGSKEWED| Distinct | 1131 |
|---|---|
| Distinct (%) | 44.7% |
| Missing | 71 |
| Missing (%) | 2.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1299.230222 |
| Minimum | 0 |
|---|---|
| Maximum | 259328 |
| Zeros | 2 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 20.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 22 |
| Q1 | 87.75 |
| median | 255.5 |
| Q3 | 724.5 |
| 95-th percentile | 4167.95 |
| Maximum | 259328 |
| Range | 259328 |
| Interquartile range (IQR) | 636.75 |
Descriptive statistics
| Standard deviation | 7043.917854 |
|---|---|
| Coefficient of variation (CV) | 5.421608686 |
| Kurtosis | 769.8256506 |
| Mean | 1299.230222 |
| Median Absolute Deviation (MAD) | 204.5 |
| Skewness | 23.84829317 |
| Sum | 3284454 |
| Variance | 49616778.73 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 13 | 15 | 0.6% |
| 30 | 14 | 0.5% |
| 34 | 14 | 0.5% |
| 14 | 13 | 0.5% |
| 18 | 13 | 0.5% |
| 35 | 13 | 0.5% |
| 28 | 13 | 0.5% |
| 40 | 13 | 0.5% |
| 17 | 12 | 0.5% |
| 22 | 12 | 0.5% |
| Other values (1121) | 2396 | |
| (Missing) | 71 | 2.7% |
| Value | Count | Frequency (%) |
| 0 | 2 | 0.1% |
| 11 | 8 | |
| 12 | 9 | |
| 13 | 15 | |
| 14 | 13 | |
| 15 | 9 | |
| 16 | 10 | |
| 17 | 12 | |
| 18 | 13 | |
| 19 | 10 |
| Value | Count | Frequency (%) |
| 259328 | 1 | |
| 124985 | 1 | |
| 94440 | 1 | |
| 66926 | 1 | |
| 59838 | 1 | |
| 54548 | 1 | |
| 44536 | 1 | |
| 39504 | 1 | |
| 38996 | 1 | |
| 37355 | 1 |
> 150% to ≤ 200% of FPL
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSING| Distinct | 990 |
|---|---|
| Distinct (%) | 39.0% |
| Missing | 59 |
| Missing (%) | 2.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 822.8456693 |
| Minimum | 0 |
|---|---|
| Maximum | 72468 |
| Zeros | 3 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 20.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 27 |
| Q1 | 87 |
| median | 201 |
| Q3 | 521 |
| 95-th percentile | 3206.65 |
| Maximum | 72468 |
| Range | 72468 |
| Interquartile range (IQR) | 434 |
Descriptive statistics
| Standard deviation | 3005.346184 |
|---|---|
| Coefficient of variation (CV) | 3.652381359 |
| Kurtosis | 224.097408 |
| Mean | 822.8456693 |
| Median Absolute Deviation (MAD) | 145 |
| Skewness | 12.82725677 |
| Sum | 2090028 |
| Variance | 9032105.684 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 50 | 20 | 0.8% |
| 107 | 15 | 0.6% |
| 74 | 14 | 0.5% |
| 71 | 14 | 0.5% |
| 14 | 13 | 0.5% |
| 33 | 13 | 0.5% |
| 48 | 13 | 0.5% |
| 41 | 13 | 0.5% |
| 84 | 12 | 0.5% |
| 27 | 12 | 0.5% |
| Other values (980) | 2401 | |
| (Missing) | 59 | 2.3% |
| Value | Count | Frequency (%) |
| 0 | 3 | 0.1% |
| 11 | 3 | 0.1% |
| 12 | 4 | 0.2% |
| 13 | 8 | |
| 14 | 13 | |
| 15 | 4 | 0.2% |
| 16 | 10 | |
| 17 | 8 | |
| 18 | 9 | |
| 19 | 10 |
| Value | Count | Frequency (%) |
| 72468 | 1 | |
| 49639 | 1 | |
| 49527 | 1 | |
| 45331 | 1 | |
| 42206 | 1 | |
| 28740 | 1 | |
| 28515 | 1 | |
| 21794 | 1 | |
| 21064 | 1 | |
| 20868 | 1 |
> 200% to ≤ 250% of FPL
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSING| Distinct | 818 |
|---|---|
| Distinct (%) | 32.6% |
| Missing | 93 |
| Missing (%) | 3.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 481.0794094 |
| Minimum | 0 |
|---|---|
| Maximum | 29140 |
| Zeros | 6 |
| Zeros (%) | 0.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 20.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 19 |
| Q1 | 53 |
| median | 121.5 |
| Q3 | 325.75 |
| 95-th percentile | 1903.5 |
| Maximum | 29140 |
| Range | 29140 |
| Interquartile range (IQR) | 272.75 |
Descriptive statistics
| Standard deviation | 1551.151442 |
|---|---|
| Coefficient of variation (CV) | 3.224314763 |
| Kurtosis | 146.2784572 |
| Mean | 481.0794094 |
| Median Absolute Deviation (MAD) | 85.5 |
| Skewness | 10.42576763 |
| Sum | 1205585 |
| Variance | 2406070.796 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 33 | 24 | 0.9% |
| 46 | 22 | 0.8% |
| 34 | 22 | 0.8% |
| 42 | 21 | 0.8% |
| 70 | 20 | 0.8% |
| 30 | 20 | 0.8% |
| 36 | 19 | 0.7% |
| 27 | 19 | 0.7% |
| 57 | 18 | 0.7% |
| 24 | 18 | 0.7% |
| Other values (808) | 2303 | |
| (Missing) | 93 | 3.6% |
| Value | Count | Frequency (%) |
| 0 | 6 | 0.2% |
| 11 | 13 | |
| 12 | 18 | |
| 13 | 14 | |
| 14 | 11 | |
| 15 | 17 | |
| 16 | 11 | |
| 17 | 14 | |
| 18 | 14 | |
| 19 | 14 |
| Value | Count | Frequency (%) |
| 29140 | 1 | |
| 26658 | 1 | |
| 26074 | 1 | |
| 21759 | 1 | |
| 20043 | 1 | |
| 16328 | 1 | |
| 15507 | 1 | |
| 13529 | 1 | |
| 10968 | 1 | |
| 10585 | 1 |
> 250% to ≤ 300% of FPL
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSING| Distinct | 639 |
|---|---|
| Distinct (%) | 26.9% |
| Missing | 223 |
| Missing (%) | 8.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 294.8813131 |
| Minimum | 0 |
|---|---|
| Maximum | 14731 |
| Zeros | 12 |
| Zeros (%) | 0.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 20.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 15 |
| Q1 | 35 |
| median | 81 |
| Q3 | 206.25 |
| 95-th percentile | 1212.5 |
| Maximum | 14731 |
| Range | 14731 |
| Interquartile range (IQR) | 171.25 |
Descriptive statistics
| Standard deviation | 839.2077704 |
|---|---|
| Coefficient of variation (CV) | 2.845917096 |
| Kurtosis | 111.1421355 |
| Mean | 294.8813131 |
| Median Absolute Deviation (MAD) | 56 |
| Skewness | 8.90686743 |
| Sum | 700638 |
| Variance | 704269.6819 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 24 | 33 | 1.3% |
| 19 | 32 | 1.2% |
| 26 | 29 | 1.1% |
| 16 | 29 | 1.1% |
| 14 | 29 | 1.1% |
| 20 | 28 | 1.1% |
| 23 | 28 | 1.1% |
| 27 | 26 | 1.0% |
| 32 | 26 | 1.0% |
| 29 | 24 | 0.9% |
| Other values (629) | 2092 | |
| (Missing) | 223 | 8.6% |
| Value | Count | Frequency (%) |
| 0 | 12 | 0.5% |
| 11 | 18 | |
| 12 | 23 | |
| 13 | 19 | |
| 14 | 29 | |
| 15 | 24 | |
| 16 | 29 | |
| 17 | 20 | |
| 18 | 24 | |
| 19 | 32 |
| Value | Count | Frequency (%) |
| 14731 | 1 | |
| 14360 | 1 | |
| 10810 | 1 | |
| 10529 | 1 | |
| 10090 | 1 | |
| 8537 | 1 | |
| 8318 | 1 | |
| 7044 | 1 | |
| 5610 | 1 | |
| 5575 | 1 |
> 300% to ≤ 400% of FPL
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSING| Distinct | 616 |
|---|---|
| Distinct (%) | 27.0% |
| Missing | 319 |
| Missing (%) | 12.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 274.3609649 |
| Minimum | 0 |
|---|---|
| Maximum | 14205 |
| Zeros | 13 |
| Zeros (%) | 0.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 20.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 14 |
| Q1 | 32 |
| median | 73 |
| Q3 | 196.25 |
| 95-th percentile | 1181.95 |
| Maximum | 14205 |
| Range | 14205 |
| Interquartile range (IQR) | 164.25 |
Descriptive statistics
| Standard deviation | 740.8567103 |
|---|---|
| Coefficient of variation (CV) | 2.700299259 |
| Kurtosis | 106.9444524 |
| Mean | 274.3609649 |
| Median Absolute Deviation (MAD) | 51 |
| Skewness | 8.443658417 |
| Sum | 625543 |
| Variance | 548868.6652 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 18 | 35 | 1.3% |
| 14 | 35 | 1.3% |
| 25 | 34 | 1.3% |
| 29 | 32 | 1.2% |
| 20 | 32 | 1.2% |
| 21 | 31 | 1.2% |
| 13 | 31 | 1.2% |
| 12 | 30 | 1.2% |
| 30 | 29 | 1.1% |
| 19 | 29 | 1.1% |
| Other values (606) | 1962 | |
| (Missing) | 319 | 12.3% |
| Value | Count | Frequency (%) |
| 0 | 13 | 0.5% |
| 11 | 25 | |
| 12 | 30 | |
| 13 | 31 | |
| 14 | 35 | |
| 15 | 21 | |
| 16 | 21 | |
| 17 | 23 | |
| 18 | 35 | |
| 19 | 29 |
| Value | Count | Frequency (%) |
| 14205 | 1 | |
| 11740 | 1 | |
| 8722 | 1 | |
| 7838 | 1 | |
| 7250 | 1 | |
| 6944 | 1 | |
| 6707 | 1 | |
| 5612 | 1 | |
| 5108 | 1 | |
| 4705 | 1 |
> 400% of FPL
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSINGZEROS| Distinct | 306 |
|---|---|
| Distinct (%) | 23.3% |
| Missing | 1283 |
| Missing (%) | 49.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 120.9825228 |
| Minimum | 0 |
|---|---|
| Maximum | 6068 |
| Zeros | 214 |
| Zeros (%) | 8.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 20.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 14 |
| median | 29 |
| Q3 | 84 |
| 95-th percentile | 555.75 |
| Maximum | 6068 |
| Range | 6068 |
| Interquartile range (IQR) | 70 |
Descriptive statistics
| Standard deviation | 342.8880701 |
|---|---|
| Coefficient of variation (CV) | 2.834195073 |
| Kurtosis | 112.3570906 |
| Mean | 120.9825228 |
| Median Absolute Deviation (MAD) | 26 |
| Skewness | 8.786321047 |
| Sum | 159213 |
| Variance | 117572.2286 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 214 | 8.2% |
| 13 | 34 | 1.3% |
| 15 | 33 | 1.3% |
| 11 | 33 | 1.3% |
| 12 | 31 | 1.2% |
| 17 | 29 | 1.1% |
| 16 | 29 | 1.1% |
| 14 | 27 | 1.0% |
| 18 | 26 | 1.0% |
| 19 | 26 | 1.0% |
| Other values (296) | 834 | |
| (Missing) | 1283 |
| Value | Count | Frequency (%) |
| 0 | 214 | |
| 11 | 33 | 1.3% |
| 12 | 31 | 1.2% |
| 13 | 34 | 1.3% |
| 14 | 27 | 1.0% |
| 15 | 33 | 1.3% |
| 16 | 29 | 1.1% |
| 17 | 29 | 1.1% |
| 18 | 26 | 1.0% |
| 19 | 26 | 1.0% |
| Value | Count | Frequency (%) |
| 6068 | 1 | |
| 4611 | 1 | |
| 4115 | 1 | |
| 2716 | 1 | |
| 2333 | 1 | |
| 2257 | 1 | |
| 2253 | 1 | |
| 1946 | 1 | |
| 1820 | 1 | |
| 1597 | 1 |
Unknown
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSINGZEROS| Distinct | 523 |
|---|---|
| Distinct (%) | 26.8% |
| Missing | 650 |
| Missing (%) | 25.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 268.5464341 |
| Minimum | 0 |
|---|---|
| Maximum | 16503 |
| Zeros | 49 |
| Zeros (%) | 1.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 20.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 12 |
| Q1 | 25 |
| median | 53 |
| Q3 | 150 |
| 95-th percentile | 1168.4 |
| Maximum | 16503 |
| Range | 16503 |
| Interquartile range (IQR) | 125 |
Descriptive statistics
| Standard deviation | 904.1691085 |
|---|---|
| Coefficient of variation (CV) | 3.366900445 |
| Kurtosis | 143.5895666 |
| Mean | 268.5464341 |
| Median Absolute Deviation (MAD) | 36 |
| Skewness | 10.16087114 |
| Sum | 523397 |
| Variance | 817521.7767 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 49 | 1.9% |
| 11 | 37 | 1.4% |
| 15 | 37 | 1.4% |
| 14 | 36 | 1.4% |
| 13 | 35 | 1.3% |
| 18 | 34 | 1.3% |
| 17 | 32 | 1.2% |
| 12 | 32 | 1.2% |
| 16 | 31 | 1.2% |
| 26 | 30 | 1.2% |
| Other values (513) | 1596 | |
| (Missing) | 650 |
| Value | Count | Frequency (%) |
| 0 | 49 | |
| 11 | 37 | |
| 12 | 32 | |
| 13 | 35 | |
| 14 | 36 | |
| 15 | 37 | |
| 16 | 31 | |
| 17 | 32 | |
| 18 | 34 | |
| 19 | 26 |
| Value | Count | Frequency (%) |
| 16503 | 1 | |
| 15654 | 1 | |
| 14602 | 1 | |
| 9096 | 1 | |
| 8458 | 1 | |
| 7398 | 1 | |
| 7111 | 1 | |
| 6009 | 1 | |
| 5748 | 1 | |
| 5443 | 1 |
Total Plan Selections
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 1729 |
|---|---|
| Distinct (%) | 66.6% |
| Missing | 2 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3403.268387 |
| Minimum | 12 |
|---|---|
| Maximum | 392442 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 20.4 KiB |
Quantile statistics
| Minimum | 12 |
|---|---|
| 5-th percentile | 86.8 |
| Q1 | 324 |
| median | 790 |
| Q3 | 2068 |
| 95-th percentile | 12913.6 |
| Maximum | 392442 |
| Range | 392430 |
| Interquartile range (IQR) | 1744 |
Descriptive statistics
| Standard deviation | 13482.9973 |
|---|---|
| Coefficient of variation (CV) | 3.96177902 |
| Kurtosis | 342.4611756 |
| Mean | 3403.268387 |
| Median Absolute Deviation (MAD) | 586 |
| Skewness | 15.37310029 |
| Sum | 8838288 |
| Variance | 181791216.1 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 145 | 7 | 0.3% |
| 100 | 7 | 0.3% |
| 82 | 7 | 0.3% |
| 126 | 6 | 0.2% |
| 62 | 6 | 0.2% |
| 204 | 6 | 0.2% |
| 164 | 5 | 0.2% |
| 122 | 5 | 0.2% |
| 163 | 5 | 0.2% |
| 203 | 5 | 0.2% |
| Other values (1719) | 2538 |
| Value | Count | Frequency (%) |
| 12 | 2 | |
| 13 | 2 | |
| 14 | 1 | < 0.1% |
| 15 | 3 | |
| 17 | 1 | < 0.1% |
| 19 | 1 | < 0.1% |
| 21 | 1 | < 0.1% |
| 22 | 1 | < 0.1% |
| 24 | 1 | < 0.1% |
| 26 | 2 |
| Value | Count | Frequency (%) |
| 392442 | 1 | |
| 226789 | 1 | |
| 222210 | 1 | |
| 157223 | 1 | |
| 136968 | 1 | |
| 129539 | 1 | |
| 128502 | 1 | |
| 108585 | 1 | |
| 94838 | 1 | |
| 94093 | 1 |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| County FIPS Code | State Name | County Name | < 100% of FPL | ≥ 100% to ≤ 150% of FPL | > 150% to ≤ 200% of FPL | > 200% to ≤ 250% of FPL | > 250% to ≤ 300% of FPL | > 300% to ≤ 400% of FPL | > 400% of FPL | Unknown | Total Plan Selections | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2013 | AK | Aleutians East Borough | NaN | 12.0 | NaN | NaN | NaN | NaN | 0.0 | NaN | 29.0 |
| 1 | 2016 | AK | Aleutians West Census Area | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 34.0 |
| 2 | 2020 | AK | Anchorage Municipality | 382.0 | 2373.0 | 1901.0 | 1620.0 | 948.0 | 896.0 | 163.0 | 465.0 | 8748.0 |
| 3 | 2050 | AK | Bethel Census Area | 12.0 | 12.0 | 18.0 | 20.0 | NaN | NaN | NaN | NaN | 83.0 |
| 4 | 2060 | AK | Bristol Bay Borough | 0.0 | NaN | NaN | 11.0 | NaN | NaN | NaN | 0.0 | 29.0 |
| 5 | 2068 | AK | Denali Borough | NaN | 39.0 | 30.0 | 30.0 | 29.0 | 20.0 | NaN | NaN | 163.0 |
| 6 | 2070 | AK | Dillingham Census Area | NaN | NaN | 13.0 | NaN | NaN | NaN | NaN | NaN | 39.0 |
| 7 | 2090 | AK | Fairbanks North Star Borough | 61.0 | 617.0 | 494.0 | 367.0 | 229.0 | 242.0 | 39.0 | 65.0 | 2114.0 |
| 8 | 2100 | AK | Haines Borough | NaN | 76.0 | 50.0 | 60.0 | 27.0 | 34.0 | NaN | NaN | 266.0 |
| 9 | 2105 | AK | Hoonah-Angoon Census Area | NaN | 44.0 | 32.0 | 16.0 | 12.0 | NaN | NaN | 0.0 | 119.0 |
Last rows
| County FIPS Code | State Name | County Name | < 100% of FPL | ≥ 100% to ≤ 150% of FPL | > 150% to ≤ 200% of FPL | > 200% to ≤ 250% of FPL | > 250% to ≤ 300% of FPL | > 300% to ≤ 400% of FPL | > 400% of FPL | Unknown | Total Plan Selections | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2589 | 56029 | WY | Park County | 22.0 | 414.0 | 356.0 | 290.0 | 196.0 | 178.0 | 16.0 | 65.0 | 1537.0 |
| 2590 | 56031 | WY | Platte County | NaN | 64.0 | 74.0 | 52.0 | 35.0 | 51.0 | NaN | 13.0 | 295.0 |
| 2591 | 56033 | WY | Sheridan County | 25.0 | 282.0 | 240.0 | 204.0 | 171.0 | 186.0 | 13.0 | 55.0 | 1176.0 |
| 2592 | 56035 | WY | Sublette County | NaN | 104.0 | 93.0 | 105.0 | 54.0 | 101.0 | NaN | 14.0 | 481.0 |
| 2593 | 56037 | WY | Sweetwater County | 21.0 | 307.0 | 210.0 | 171.0 | 115.0 | 126.0 | 18.0 | 50.0 | 1018.0 |
| 2594 | 56039 | WY | Teton County | 26.0 | 529.0 | 583.0 | 522.0 | 403.0 | 522.0 | 37.0 | 100.0 | 2722.0 |
| 2595 | 56041 | WY | Uinta County | NaN | 165.0 | 130.0 | 86.0 | 59.0 | 51.0 | NaN | 22.0 | 538.0 |
| 2596 | 56043 | WY | Washakie County | NaN | 98.0 | 77.0 | 46.0 | 21.0 | 56.0 | NaN | NaN | 319.0 |
| 2597 | 56045 | WY | Weston County | NaN | 54.0 | 22.0 | 36.0 | 20.0 | 22.0 | NaN | NaN | 161.0 |
| 2598 | XXXXX | XX | Unknown | 28.0 | 173.0 | 132.0 | 62.0 | 42.0 | 24.0 | 17.0 | 25.0 | 503.0 |